﻿DROP TABLE IF EXISTS `open_order_return`;
CREATE TABLE `open_order_return` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `return_sn` varchar(20) NOT NULL DEFAULT '0',
  `relating_order_sn` varchar(20) NOT NULL DEFAULT '0',
  `return_order_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `return_order_ispass` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `return_reason` smallint(5) unsigned NOT NULL DEFAULT '0',
  `return_pay` smallint(5) unsigned NOT NULL DEFAULT '0',
  `action_user` varchar(30) NOT NULL DEFAULT '0',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0',
  `return_consignee` varchar(60) NOT NULL DEFAULT '0',
  `return_tel` varchar(60) NOT NULL DEFAULT '0',
  `return_mobile` varchar(60) NOT NULL DEFAULT '0',
  `return_email` varchar(60) NOT NULL DEFAULT '0',
  `return_address` varchar(255) NOT NULL DEFAULT '0',
  `return_zipcode` varchar(60) NOT NULL DEFAULT '0',
  `return_goods_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `return_total_fee` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `return_type` enum('1','2') NOT NULL default '1',
  `rj` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`return_sn`),
  KEY `type` (`return_order_status`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;